home *** CD-ROM | disk | FTP | other *** search
/ Programmer Plus 2007 / Programmer-Plus-2007.iso / Programming / SQL and Data Base / Logic Works ERwin 3.5 / data.1 / ERTMPL32.DLL / RCDATA / 1813 < prev    next >
Unknown  |  1998-01-30  |  356 b 
open in: MacOS 8.1     |     Win98     |     DOS

view JSON data     |     view as text


This file was not able to be converted.
This format is not currently supported by dexvert.

ConfidenceProgramDetectionMatch TypeSupport
100% file data default
100% disktype Blank disk/medium default (weak)


hex view
+--------+-------------------------+-------------------------+--------+--------+
|00000000| 43 48 49 4c 44 20 44 45 | 4c 45 54 45 20 52 45 53 |CHILD DE|LETE RES|
|00000010| 54 52 49 43 54 00 20 20 | 20 20 2d 2d 20 45 52 77 |TRICT.  |  -- ERw|
|00000020| 69 6e 20 42 75 69 6c 74 | 69 6e 20 25 44 61 74 65 |in Built|in %Date|
|00000030| 74 69 6d 65 20 0d 0a 20 | 20 20 20 2d 2d 20 25 50 |time .. |   -- %P|
|00000040| 61 72 65 6e 74 20 25 56 | 65 72 62 50 68 72 61 73 |arent %V|erbPhras|
|00000050| 65 20 25 43 68 69 6c 64 | 20 4f 4e 20 43 48 49 4c |e %Child| ON CHIL|
|00000060| 44 20 44 45 4c 45 54 45 | 20 52 45 53 54 52 49 43 |D DELETE| RESTRIC|
|00000070| 54 20 0d 0a 20 20 20 20 | 73 65 6c 65 63 74 20 63 |T ..    |select c|
|00000080| 6f 75 6e 74 28 2a 29 20 | 69 6e 74 6f 20 6e 75 6d |ount(*) |into num|
|00000090| 72 6f 77 73 20 66 72 6f | 6d 20 25 50 61 72 65 6e |rows fro|m %Paren|
|000000a0| 74 0d 0a 20 20 20 20 20 | 20 77 68 65 72 65 0d 0a |t..     | where..|
|000000b0| 20 20 20 20 20 20 20 20 | 2d 2d 20 25 25 4a 6f 69 |        |-- %%Joi|
|000000c0| 6e 46 4b 50 4b 28 25 4f | 6c 64 2c 25 50 61 72 65 |nFKPK(%O|ld,%Pare|
|000000d0| 6e 74 2c 22 20 3d 20 22 | 2c 22 20 61 6e 64 22 29 |nt," = "|," and")|
|000000e0| 20 0d 0a 20 20 20 20 20 | 20 20 20 25 4a 6f 69 6e | ..     |   %Join|
|000000f0| 46 4b 50 4b 28 25 4f 6c | 64 2c 25 50 61 72 65 6e |FKPK(%Ol|d,%Paren|
|00000100| 74 2c 22 20 3d 20 22 2c | 22 20 61 6e 64 22 29 3b |t," = ",|" and");|
|00000110| 0d 0a 20 20 20 20 69 66 | 20 28 6e 75 6d 72 6f 77 |..    if| (numrow|
|00000120| 73 20 3e 20 30 29 0d 0a | 20 20 20 20 74 68 65 6e |s > 0)..|    then|
|00000130| 0d 0a 20 20 20 20 20 20 | 73 69 67 6e 61 6c 20 63 |..      |signal c|
|00000140| 68 69 6c 64 5f 64 65 6c | 72 73 74 72 63 74 5f 65 |hild_del|rstrct_e|
|00000150| 72 72 0d 0a 20 20 20 20 | 65 6e 64 20 69 66 3b 0d |rr..    |end if;.|
|00000160| 0a 00 20 27             |                         |.. '    |        |
+--------+-------------------------+-------------------------+--------+--------+